<?php
include_once("../c/config.php");
$mysqli = new mysqli($dbhost, $dbuser, $dbpwd, $dbName);
if (!$mysqli->set_charset("utf8")) {printf("Error loading character set utf8: %s\n", $mysqliTwo->error);}
 

$q=$mysqli->query('SELECT * FROM `uinfo` ');

while ($list=$q->fetch_assoc()){
    var_dump($list);
    echo '<br />';
    $qu=$mysqli->query('SELECT * FROM `users` where openid="'.$list['openid'].'"  ');
    $u=$qu->fetch_assoc();
    echo base64_decode($u['nickname']);
    echo '<br />';
    var_dump($u);
    echo '<br />';
    
    $ql=$mysqli->query('SELECT * FROM `ling` where openid="'.$list['openid'].'"  ');
    $l=$ql->fetch_assoc();
    var_dump($l);
    
    echo '<br /><br />';
    echo '.......................';
    echo '<br /><br /><br /><br /><br /><br />';
}

$list=array();
$list['openid']='oe2K2jh2um_A2ZD51YN9EjA1wtjY';

var_dump($list);
    echo '<br />';
    $qu=$mysqli->query('SELECT * FROM `users` where openid="'.$list['openid'].'"  ');
    $u=$qu->fetch_assoc();
    echo base64_decode($u['nickname']);
    echo '<br />';
    var_dump($u);
    echo '<br />';
    
    $ql=$mysqli->query('SELECT * FROM `ling` where openid="'.$list['openid'].'"  ');
    $l=$ql->fetch_assoc();
    var_dump($l);
    
    echo '<br /><br />';
    echo '.......................';
    echo '<br /><br /><br /><br /><br /><br />';

 

$list=array();
$list['openid']='oe2K2jjJ4Bkkima2HgpwF2XbRj14';

var_dump($list);
    echo '<br />';
    $qu=$mysqli->query('SELECT * FROM `users` where openid="'.$list['openid'].'"  ');
    $u=$qu->fetch_assoc();
    echo base64_decode($u['nickname']);
    echo '<br />';
    var_dump($u);
    echo '<br />';
    
    $ql=$mysqli->query('SELECT * FROM `ling` where openid="'.$list['openid'].'"  ');
    $l=$ql->fetch_assoc();
    var_dump($l);
    
    echo '<br /><br />';
    echo '.......................';
    echo '<br /><br /><br /><br /><br /><br />';